Add OL records in the order in which you want them to display in the transaction field. The total number of order lines following an OH record is verified against the number of lines specified in the header.
Record # |
Field Name |
Data Type |
Comments |
---|---|---|---|
1 |
Record Type |
OL |
Required: Always OL |
2 |
Product Code |
Char (31) |
Optional: If not used, the Description becomes a required field. If specified, must exist in the Product table. |
3 |
Product Description |
Char (225) |
Required if product code is left blank. Optional if product code is used. Used to override the product description for this order. |
4 |
Quantity Ordered |
Numeric |
Optional |
5 |
Unit Price |
Money |
Optional: Used to override the unit price in the Product table. |
6 |
Taxable |
Boolean |
Optional: Used to override the product taxation status. |
7 |
Commission Rate |
Numeric |
Optional: Used to override the commission rate contained in the Product table. (Do not express the commission rate percentage as a decimal or fraction. Use a whole number.) |
8 |
Discount |
Numeric |
Optional: Used to enter product-level discounts. Product-level discounts override order-level discounts for product line-items. |
9 |
Location |
Char (10) |
Optional: Used to enter a warehouse location when using multiple warehouses. |
10 |
Bin |
Char (10) |
Optional: Used to enter a storage bin within a warehouse. |
11 |
UF_1 |
Char (30) |
Optional: Used to enter and define specific order information for products. |
12 |
UF_2 |
||
13 |
UF_3 |
||
14 |
UF_4 |
10.6 Production Release. Updated 3/20/2006 12:52:04 PM
© Copyright by Advanced Solutions International, Inc.
All rights reserved.